package com.njts.dao;

import com.njts.bean.*;
import com.njts.bean.Class;

import java.util.List;

public interface Dao {
    public User login(String name,String password);

    public List<Student>  selectStudent();

    public List<Teacher> selectTeacher();

    public List<Course> selectCourse();

    public List<Score> selectScore();

    public List<Class> selectClass();

    public List<Subject> selectSubject();

    public List<User> selectUser();

    public boolean deleteStudentById(int id);

    public boolean insertStudent(String valuesComplementSql);

    public boolean updateStudent(String setComplementSql,int id);

    public List<Student> selectStudent(String whereComplementSql);
    public boolean deleteTeacher(int id);

    public boolean updateTeacher(String setComplementSql,int id);

    public boolean insertTeacher(String valuesComplementSql);

    public List<Teacher> selectTeacher(String  whereComplementSql);

    public boolean insertCourse(String valuesComplementSql);

    public boolean updateCourse(String setComplementSql,int id);

    public boolean deleteCourse(int id);

    public List<Course> selectCourse(String  whereComplementSql);

    public boolean insertScore(String valuesComplementSql);

    public boolean deleteScore(int id);

    public boolean updateScore(String setComplementSql,int id);

    public List<Score> selectScore(String whereComplementSql);

    public boolean insertClass(String valuesComplementSql);

    public boolean updateClass(String setComplementSql,int id);

    public boolean deleteClass(int id);

    public List<Class> selectClass(String whereComplementSql);

    public boolean insertSubject(String valuesComplementSql);

    public boolean updateSubject(String setComplementSql,int id);

    public boolean deleteSubject(int id);

    public List<Subject> selectSubject(String whereComplementSql);

    public boolean insertUser(String valuesComplementSql);

    public boolean updateUser(String setComplementSql,int id);

    public boolean deleteUser(int id);

    public List<User> selectUser(String whereComplementSql);

}
